-
Re: Are Automations Reliable?
@AFlint, I was actually kind of lazy about it. I have a summary sheet with a column for each Archive Sheet. In that summary sheet, I have 3 columns - threshold, counter, percent of threshold. In my t…1 · -
Re: Weekly requests Received & Sent
@Dan Bourque , I would suggest using the =WEEKNUMBER function in a helper column for each of your date ranges, then using a COUNTIF to summarize for WK 1 through WK 51. Smartsheet always starts WK 1 …1 · -
Re: Multiple IF Formula for Matrix
@Lisa Matthews2 , hey there! I have some ideas, but I need to understand the impacts better to flesh them out. Does people vs process vs tech hold different weightings? Or is it 2 out of 3 means go h…1 · -
Re: Multiple IF Formula for Matrix
Hi, @Lisa Matthews2 , I generally just include a key that shows what the numeric values of each alpha are, and only allow a single value for each one: High = 9 Med = 6 Low = 1 None = 0 Then you don't…1 · -
Re: Why are ALL rows on the Auto-Number/System Column filled?
Hi, @Gerhard da Costa Pinto , In your risk log, do you have a formula that has been converted to a column formula? If so, your auto-generated ID will populate all exposed (50) rows because it recogni…1 ·
